package com.seraph.zys.dao.impl;

import com.seraph.bi.suite.support.domain.pagination.PageBox;
import com.seraph.bi.suite.support.domain.pagination.PageObject;
import com.seraph.zys.dao.PccPaPatientsManageFeeDAO;
import com.seraph.zys.dao.domain.PccPaPatientsManageFee;
import com.seraph.zys.dao.domain.PccPaPatientsManageFeeExample;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
import org.springframework.stereotype.Repository;

@Repository
public class PccPaPatientsManageFeeDAOImpl extends SqlMapClientDaoSupport implements PccPaPatientsManageFeeDAO {

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    public PccPaPatientsManageFeeDAOImpl() {
        super();
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    public Integer insert(PccPaPatientsManageFee record) {
        Object newKey = getSqlMapClientTemplate().insert("pcc_pa_patients_manage_fee.abatorgenerated_insert", record);
        return (Integer) newKey;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    public int updateByPrimaryKey(PccPaPatientsManageFee record) {
        int rows = getSqlMapClientTemplate().update("pcc_pa_patients_manage_fee.abatorgenerated_updateByPrimaryKey", record);
        return rows;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    public int updateByPrimaryKeySelective(PccPaPatientsManageFee record) {
        int rows = getSqlMapClientTemplate().update("pcc_pa_patients_manage_fee.abatorgenerated_updateByPrimaryKeySelective", record);
        return rows;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    public List selectByExample(PccPaPatientsManageFeeExample example, String orderByClause) {
        Map parms = getExampleParms(example);
        if (orderByClause != null) {
            parms.put("ABATOR_ORDER_BY_CLAUSE", orderByClause);
        }
        List list = getSqlMapClientTemplate().queryForList("pcc_pa_patients_manage_fee.abatorgenerated_selectByExample", parms);
        return list;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    public List selectByExample(PccPaPatientsManageFeeExample example) {
        return selectByExample(example, null);
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    public PccPaPatientsManageFee selectByPrimaryKey(Integer id) {
        PccPaPatientsManageFee key = new PccPaPatientsManageFee();
        key.setId(id);
        PccPaPatientsManageFee record = (PccPaPatientsManageFee) getSqlMapClientTemplate().queryForObject("pcc_pa_patients_manage_fee.abatorgenerated_selectByPrimaryKey", key);
        return record;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    public int deleteByExample(PccPaPatientsManageFeeExample example) {
        int rows = getSqlMapClientTemplate().delete("pcc_pa_patients_manage_fee.abatorgenerated_deleteByExample", getExampleParms(example));
        return rows;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    public int deleteByPrimaryKey(Integer id) {
        PccPaPatientsManageFee key = new PccPaPatientsManageFee();
        key.setId(id);
        int rows = getSqlMapClientTemplate().delete("pcc_pa_patients_manage_fee.abatorgenerated_deleteByPrimaryKey", key);
        return rows;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    private Map getIDExampleParms(PccPaPatientsManageFeeExample example) {
        Map parms = new HashMap();
        switch (example.getId_Indicator()) {
        case PccPaPatientsManageFeeExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ID_NULL", "Y");
            } else {
                parms.put("AND_ID_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ID_NOT_NULL", "Y");
            } else {
                parms.put("AND_ID_NOT_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ID_EQUALS", "Y");
            } else {
                parms.put("AND_ID_EQUALS", "Y");
            }
            parms.put("id", example.getId());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ID_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_ID_NOT_EQUALS", "Y");
            }
            parms.put("id", example.getId());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ID_GT", "Y");
            } else {
                parms.put("AND_ID_GT", "Y");
            }
            parms.put("id", example.getId());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ID_GE", "Y");
            } else {
                parms.put("AND_ID_GE", "Y");
            }
            parms.put("id", example.getId());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ID_LT", "Y");
            } else {
                parms.put("AND_ID_LT", "Y");
            }
            parms.put("id", example.getId());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ID_LE", "Y");
            } else {
                parms.put("AND_ID_LE", "Y");
            }
            parms.put("id", example.getId());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    private Map getFISCAL_YEARExampleParms(PccPaPatientsManageFeeExample example) {
        Map parms = new HashMap();
        switch (example.getFiscalYear_Indicator()) {
        case PccPaPatientsManageFeeExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FISCAL_YEAR_NULL", "Y");
            } else {
                parms.put("AND_FISCAL_YEAR_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FISCAL_YEAR_NOT_NULL", "Y");
            } else {
                parms.put("AND_FISCAL_YEAR_NOT_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FISCAL_YEAR_EQUALS", "Y");
            } else {
                parms.put("AND_FISCAL_YEAR_EQUALS", "Y");
            }
            parms.put("fiscalYear", example.getFiscalYear());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FISCAL_YEAR_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_FISCAL_YEAR_NOT_EQUALS", "Y");
            }
            parms.put("fiscalYear", example.getFiscalYear());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FISCAL_YEAR_GT", "Y");
            } else {
                parms.put("AND_FISCAL_YEAR_GT", "Y");
            }
            parms.put("fiscalYear", example.getFiscalYear());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FISCAL_YEAR_GE", "Y");
            } else {
                parms.put("AND_FISCAL_YEAR_GE", "Y");
            }
            parms.put("fiscalYear", example.getFiscalYear());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FISCAL_YEAR_LT", "Y");
            } else {
                parms.put("AND_FISCAL_YEAR_LT", "Y");
            }
            parms.put("fiscalYear", example.getFiscalYear());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FISCAL_YEAR_LE", "Y");
            } else {
                parms.put("AND_FISCAL_YEAR_LE", "Y");
            }
            parms.put("fiscalYear", example.getFiscalYear());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    private Map getFROM_AREAExampleParms(PccPaPatientsManageFeeExample example) {
        Map parms = new HashMap();
        switch (example.getFromArea_Indicator()) {
        case PccPaPatientsManageFeeExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FROM_AREA_NULL", "Y");
            } else {
                parms.put("AND_FROM_AREA_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FROM_AREA_NOT_NULL", "Y");
            } else {
                parms.put("AND_FROM_AREA_NOT_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FROM_AREA_EQUALS", "Y");
            } else {
                parms.put("AND_FROM_AREA_EQUALS", "Y");
            }
            parms.put("fromArea", example.getFromArea());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FROM_AREA_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_FROM_AREA_NOT_EQUALS", "Y");
            }
            parms.put("fromArea", example.getFromArea());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FROM_AREA_GT", "Y");
            } else {
                parms.put("AND_FROM_AREA_GT", "Y");
            }
            parms.put("fromArea", example.getFromArea());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FROM_AREA_GE", "Y");
            } else {
                parms.put("AND_FROM_AREA_GE", "Y");
            }
            parms.put("fromArea", example.getFromArea());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FROM_AREA_LT", "Y");
            } else {
                parms.put("AND_FROM_AREA_LT", "Y");
            }
            parms.put("fromArea", example.getFromArea());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FROM_AREA_LE", "Y");
            } else {
                parms.put("AND_FROM_AREA_LE", "Y");
            }
            parms.put("fromArea", example.getFromArea());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FROM_AREA_LIKE", "Y");
            } else {
                parms.put("AND_FROM_AREA_LIKE", "Y");
            }
            parms.put("fromArea", example.getFromArea());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    private Map getSORT_IDExampleParms(PccPaPatientsManageFeeExample example) {
        Map parms = new HashMap();
        switch (example.getSortId_Indicator()) {
        case PccPaPatientsManageFeeExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SORT_ID_NULL", "Y");
            } else {
                parms.put("AND_SORT_ID_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SORT_ID_NOT_NULL", "Y");
            } else {
                parms.put("AND_SORT_ID_NOT_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SORT_ID_EQUALS", "Y");
            } else {
                parms.put("AND_SORT_ID_EQUALS", "Y");
            }
            parms.put("sortId", example.getSortId());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SORT_ID_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_SORT_ID_NOT_EQUALS", "Y");
            }
            parms.put("sortId", example.getSortId());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SORT_ID_GT", "Y");
            } else {
                parms.put("AND_SORT_ID_GT", "Y");
            }
            parms.put("sortId", example.getSortId());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SORT_ID_GE", "Y");
            } else {
                parms.put("AND_SORT_ID_GE", "Y");
            }
            parms.put("sortId", example.getSortId());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SORT_ID_LT", "Y");
            } else {
                parms.put("AND_SORT_ID_LT", "Y");
            }
            parms.put("sortId", example.getSortId());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_SORT_ID_LE", "Y");
            } else {
                parms.put("AND_SORT_ID_LE", "Y");
            }
            parms.put("sortId", example.getSortId());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    private Map getPATIENTSExampleParms(PccPaPatientsManageFeeExample example) {
        Map parms = new HashMap();
        switch (example.getPatients_Indicator()) {
        case PccPaPatientsManageFeeExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PATIENTS_NULL", "Y");
            } else {
                parms.put("AND_PATIENTS_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PATIENTS_NOT_NULL", "Y");
            } else {
                parms.put("AND_PATIENTS_NOT_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PATIENTS_EQUALS", "Y");
            } else {
                parms.put("AND_PATIENTS_EQUALS", "Y");
            }
            parms.put("patients", example.getPatients());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PATIENTS_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_PATIENTS_NOT_EQUALS", "Y");
            }
            parms.put("patients", example.getPatients());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PATIENTS_GT", "Y");
            } else {
                parms.put("AND_PATIENTS_GT", "Y");
            }
            parms.put("patients", example.getPatients());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PATIENTS_GE", "Y");
            } else {
                parms.put("AND_PATIENTS_GE", "Y");
            }
            parms.put("patients", example.getPatients());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PATIENTS_LT", "Y");
            } else {
                parms.put("AND_PATIENTS_LT", "Y");
            }
            parms.put("patients", example.getPatients());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PATIENTS_LE", "Y");
            } else {
                parms.put("AND_PATIENTS_LE", "Y");
            }
            parms.put("patients", example.getPatients());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LIKE:
            if (example.isCombineTypeOr()) {
                parms.put("OR_PATIENTS_LIKE", "Y");
            } else {
                parms.put("AND_PATIENTS_LIKE", "Y");
            }
            parms.put("patients", example.getPatients());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    private Map getMANAGE_FEEExampleParms(PccPaPatientsManageFeeExample example) {
        Map parms = new HashMap();
        switch (example.getManageFee_Indicator()) {
        case PccPaPatientsManageFeeExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_MANAGE_FEE_NULL", "Y");
            } else {
                parms.put("AND_MANAGE_FEE_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_MANAGE_FEE_NOT_NULL", "Y");
            } else {
                parms.put("AND_MANAGE_FEE_NOT_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_MANAGE_FEE_EQUALS", "Y");
            } else {
                parms.put("AND_MANAGE_FEE_EQUALS", "Y");
            }
            parms.put("manageFee", example.getManageFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_MANAGE_FEE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_MANAGE_FEE_NOT_EQUALS", "Y");
            }
            parms.put("manageFee", example.getManageFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_MANAGE_FEE_GT", "Y");
            } else {
                parms.put("AND_MANAGE_FEE_GT", "Y");
            }
            parms.put("manageFee", example.getManageFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_MANAGE_FEE_GE", "Y");
            } else {
                parms.put("AND_MANAGE_FEE_GE", "Y");
            }
            parms.put("manageFee", example.getManageFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_MANAGE_FEE_LT", "Y");
            } else {
                parms.put("AND_MANAGE_FEE_LT", "Y");
            }
            parms.put("manageFee", example.getManageFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_MANAGE_FEE_LE", "Y");
            } else {
                parms.put("AND_MANAGE_FEE_LE", "Y");
            }
            parms.put("manageFee", example.getManageFee());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    private Map getDRUG_BSY_FEEExampleParms(PccPaPatientsManageFeeExample example) {
        Map parms = new HashMap();
        switch (example.getDrugBsyFee_Indicator()) {
        case PccPaPatientsManageFeeExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_BSY_FEE_NULL", "Y");
            } else {
                parms.put("AND_DRUG_BSY_FEE_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_BSY_FEE_NOT_NULL", "Y");
            } else {
                parms.put("AND_DRUG_BSY_FEE_NOT_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_BSY_FEE_EQUALS", "Y");
            } else {
                parms.put("AND_DRUG_BSY_FEE_EQUALS", "Y");
            }
            parms.put("drugBsyFee", example.getDrugBsyFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_BSY_FEE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_DRUG_BSY_FEE_NOT_EQUALS", "Y");
            }
            parms.put("drugBsyFee", example.getDrugBsyFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_BSY_FEE_GT", "Y");
            } else {
                parms.put("AND_DRUG_BSY_FEE_GT", "Y");
            }
            parms.put("drugBsyFee", example.getDrugBsyFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_BSY_FEE_GE", "Y");
            } else {
                parms.put("AND_DRUG_BSY_FEE_GE", "Y");
            }
            parms.put("drugBsyFee", example.getDrugBsyFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_BSY_FEE_LT", "Y");
            } else {
                parms.put("AND_DRUG_BSY_FEE_LT", "Y");
            }
            parms.put("drugBsyFee", example.getDrugBsyFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_BSY_FEE_LE", "Y");
            } else {
                parms.put("AND_DRUG_BSY_FEE_LE", "Y");
            }
            parms.put("drugBsyFee", example.getDrugBsyFee());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    private Map getDRUG_FDC_FEEExampleParms(PccPaPatientsManageFeeExample example) {
        Map parms = new HashMap();
        switch (example.getDrugFdcFee_Indicator()) {
        case PccPaPatientsManageFeeExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_FDC_FEE_NULL", "Y");
            } else {
                parms.put("AND_DRUG_FDC_FEE_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_FDC_FEE_NOT_NULL", "Y");
            } else {
                parms.put("AND_DRUG_FDC_FEE_NOT_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_FDC_FEE_EQUALS", "Y");
            } else {
                parms.put("AND_DRUG_FDC_FEE_EQUALS", "Y");
            }
            parms.put("drugFdcFee", example.getDrugFdcFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_FDC_FEE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_DRUG_FDC_FEE_NOT_EQUALS", "Y");
            }
            parms.put("drugFdcFee", example.getDrugFdcFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_FDC_FEE_GT", "Y");
            } else {
                parms.put("AND_DRUG_FDC_FEE_GT", "Y");
            }
            parms.put("drugFdcFee", example.getDrugFdcFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_FDC_FEE_GE", "Y");
            } else {
                parms.put("AND_DRUG_FDC_FEE_GE", "Y");
            }
            parms.put("drugFdcFee", example.getDrugFdcFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_FDC_FEE_LT", "Y");
            } else {
                parms.put("AND_DRUG_FDC_FEE_LT", "Y");
            }
            parms.put("drugFdcFee", example.getDrugFdcFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_FDC_FEE_LE", "Y");
            } else {
                parms.put("AND_DRUG_FDC_FEE_LE", "Y");
            }
            parms.put("drugFdcFee", example.getDrugFdcFee());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    private Map getZDXKYZL_FEEExampleParms(PccPaPatientsManageFeeExample example) {
        Map parms = new HashMap();
        switch (example.getZdxkyzlFee_Indicator()) {
        case PccPaPatientsManageFeeExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ZDXKYZL_FEE_NULL", "Y");
            } else {
                parms.put("AND_ZDXKYZL_FEE_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ZDXKYZL_FEE_NOT_NULL", "Y");
            } else {
                parms.put("AND_ZDXKYZL_FEE_NOT_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ZDXKYZL_FEE_EQUALS", "Y");
            } else {
                parms.put("AND_ZDXKYZL_FEE_EQUALS", "Y");
            }
            parms.put("zdxkyzlFee", example.getZdxkyzlFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ZDXKYZL_FEE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_ZDXKYZL_FEE_NOT_EQUALS", "Y");
            }
            parms.put("zdxkyzlFee", example.getZdxkyzlFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ZDXKYZL_FEE_GT", "Y");
            } else {
                parms.put("AND_ZDXKYZL_FEE_GT", "Y");
            }
            parms.put("zdxkyzlFee", example.getZdxkyzlFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ZDXKYZL_FEE_GE", "Y");
            } else {
                parms.put("AND_ZDXKYZL_FEE_GE", "Y");
            }
            parms.put("zdxkyzlFee", example.getZdxkyzlFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ZDXKYZL_FEE_LT", "Y");
            } else {
                parms.put("AND_ZDXKYZL_FEE_LT", "Y");
            }
            parms.put("zdxkyzlFee", example.getZdxkyzlFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ZDXKYZL_FEE_LE", "Y");
            } else {
                parms.put("AND_ZDXKYZL_FEE_LE", "Y");
            }
            parms.put("zdxkyzlFee", example.getZdxkyzlFee());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    private Map getFFYZL_FEEExampleParms(PccPaPatientsManageFeeExample example) {
        Map parms = new HashMap();
        switch (example.getFfyzlFee_Indicator()) {
        case PccPaPatientsManageFeeExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FFYZL_FEE_NULL", "Y");
            } else {
                parms.put("AND_FFYZL_FEE_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FFYZL_FEE_NOT_NULL", "Y");
            } else {
                parms.put("AND_FFYZL_FEE_NOT_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FFYZL_FEE_EQUALS", "Y");
            } else {
                parms.put("AND_FFYZL_FEE_EQUALS", "Y");
            }
            parms.put("ffyzlFee", example.getFfyzlFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FFYZL_FEE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_FFYZL_FEE_NOT_EQUALS", "Y");
            }
            parms.put("ffyzlFee", example.getFfyzlFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FFYZL_FEE_GT", "Y");
            } else {
                parms.put("AND_FFYZL_FEE_GT", "Y");
            }
            parms.put("ffyzlFee", example.getFfyzlFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FFYZL_FEE_GE", "Y");
            } else {
                parms.put("AND_FFYZL_FEE_GE", "Y");
            }
            parms.put("ffyzlFee", example.getFfyzlFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FFYZL_FEE_LT", "Y");
            } else {
                parms.put("AND_FFYZL_FEE_LT", "Y");
            }
            parms.put("ffyzlFee", example.getFfyzlFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FFYZL_FEE_LE", "Y");
            } else {
                parms.put("AND_FFYZL_FEE_LE", "Y");
            }
            parms.put("ffyzlFee", example.getFfyzlFee());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    private Map getQTZL_FEEExampleParms(PccPaPatientsManageFeeExample example) {
        Map parms = new HashMap();
        switch (example.getQtzlFee_Indicator()) {
        case PccPaPatientsManageFeeExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_QTZL_FEE_NULL", "Y");
            } else {
                parms.put("AND_QTZL_FEE_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_QTZL_FEE_NOT_NULL", "Y");
            } else {
                parms.put("AND_QTZL_FEE_NOT_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_QTZL_FEE_EQUALS", "Y");
            } else {
                parms.put("AND_QTZL_FEE_EQUALS", "Y");
            }
            parms.put("qtzlFee", example.getQtzlFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_QTZL_FEE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_QTZL_FEE_NOT_EQUALS", "Y");
            }
            parms.put("qtzlFee", example.getQtzlFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_QTZL_FEE_GT", "Y");
            } else {
                parms.put("AND_QTZL_FEE_GT", "Y");
            }
            parms.put("qtzlFee", example.getQtzlFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_QTZL_FEE_GE", "Y");
            } else {
                parms.put("AND_QTZL_FEE_GE", "Y");
            }
            parms.put("qtzlFee", example.getQtzlFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_QTZL_FEE_LT", "Y");
            } else {
                parms.put("AND_QTZL_FEE_LT", "Y");
            }
            parms.put("qtzlFee", example.getQtzlFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_QTZL_FEE_LE", "Y");
            } else {
                parms.put("AND_QTZL_FEE_LE", "Y");
            }
            parms.put("qtzlFee", example.getQtzlFee());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    private Map getYYJTBZ_FEEExampleParms(PccPaPatientsManageFeeExample example) {
        Map parms = new HashMap();
        switch (example.getYyjtbzFee_Indicator()) {
        case PccPaPatientsManageFeeExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_YYJTBZ_FEE_NULL", "Y");
            } else {
                parms.put("AND_YYJTBZ_FEE_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_YYJTBZ_FEE_NOT_NULL", "Y");
            } else {
                parms.put("AND_YYJTBZ_FEE_NOT_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_YYJTBZ_FEE_EQUALS", "Y");
            } else {
                parms.put("AND_YYJTBZ_FEE_EQUALS", "Y");
            }
            parms.put("yyjtbzFee", example.getYyjtbzFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_YYJTBZ_FEE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_YYJTBZ_FEE_NOT_EQUALS", "Y");
            }
            parms.put("yyjtbzFee", example.getYyjtbzFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_YYJTBZ_FEE_GT", "Y");
            } else {
                parms.put("AND_YYJTBZ_FEE_GT", "Y");
            }
            parms.put("yyjtbzFee", example.getYyjtbzFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_YYJTBZ_FEE_GE", "Y");
            } else {
                parms.put("AND_YYJTBZ_FEE_GE", "Y");
            }
            parms.put("yyjtbzFee", example.getYyjtbzFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_YYJTBZ_FEE_LT", "Y");
            } else {
                parms.put("AND_YYJTBZ_FEE_LT", "Y");
            }
            parms.put("yyjtbzFee", example.getYyjtbzFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_YYJTBZ_FEE_LE", "Y");
            } else {
                parms.put("AND_YYJTBZ_FEE_LE", "Y");
            }
            parms.put("yyjtbzFee", example.getYyjtbzFee());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    private Map getMANAGE_scaleExampleParms(PccPaPatientsManageFeeExample example) {
        Map parms = new HashMap();
        switch (example.getManageScale_Indicator()) {
        case PccPaPatientsManageFeeExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_MANAGE_scale_NULL", "Y");
            } else {
                parms.put("AND_MANAGE_scale_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_MANAGE_scale_NOT_NULL", "Y");
            } else {
                parms.put("AND_MANAGE_scale_NOT_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_MANAGE_scale_EQUALS", "Y");
            } else {
                parms.put("AND_MANAGE_scale_EQUALS", "Y");
            }
            parms.put("manageScale", example.getManageScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_MANAGE_scale_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_MANAGE_scale_NOT_EQUALS", "Y");
            }
            parms.put("manageScale", example.getManageScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_MANAGE_scale_GT", "Y");
            } else {
                parms.put("AND_MANAGE_scale_GT", "Y");
            }
            parms.put("manageScale", example.getManageScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_MANAGE_scale_GE", "Y");
            } else {
                parms.put("AND_MANAGE_scale_GE", "Y");
            }
            parms.put("manageScale", example.getManageScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_MANAGE_scale_LT", "Y");
            } else {
                parms.put("AND_MANAGE_scale_LT", "Y");
            }
            parms.put("manageScale", example.getManageScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_MANAGE_scale_LE", "Y");
            } else {
                parms.put("AND_MANAGE_scale_LE", "Y");
            }
            parms.put("manageScale", example.getManageScale());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    private Map getDRUG_BSY_scaleExampleParms(PccPaPatientsManageFeeExample example) {
        Map parms = new HashMap();
        switch (example.getDrugBsyScale_Indicator()) {
        case PccPaPatientsManageFeeExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_BSY_scale_NULL", "Y");
            } else {
                parms.put("AND_DRUG_BSY_scale_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_BSY_scale_NOT_NULL", "Y");
            } else {
                parms.put("AND_DRUG_BSY_scale_NOT_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_BSY_scale_EQUALS", "Y");
            } else {
                parms.put("AND_DRUG_BSY_scale_EQUALS", "Y");
            }
            parms.put("drugBsyScale", example.getDrugBsyScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_BSY_scale_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_DRUG_BSY_scale_NOT_EQUALS", "Y");
            }
            parms.put("drugBsyScale", example.getDrugBsyScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_BSY_scale_GT", "Y");
            } else {
                parms.put("AND_DRUG_BSY_scale_GT", "Y");
            }
            parms.put("drugBsyScale", example.getDrugBsyScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_BSY_scale_GE", "Y");
            } else {
                parms.put("AND_DRUG_BSY_scale_GE", "Y");
            }
            parms.put("drugBsyScale", example.getDrugBsyScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_BSY_scale_LT", "Y");
            } else {
                parms.put("AND_DRUG_BSY_scale_LT", "Y");
            }
            parms.put("drugBsyScale", example.getDrugBsyScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_BSY_scale_LE", "Y");
            } else {
                parms.put("AND_DRUG_BSY_scale_LE", "Y");
            }
            parms.put("drugBsyScale", example.getDrugBsyScale());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    private Map getDRUG_FDC_scaleExampleParms(PccPaPatientsManageFeeExample example) {
        Map parms = new HashMap();
        switch (example.getDrugFdcScale_Indicator()) {
        case PccPaPatientsManageFeeExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_FDC_scale_NULL", "Y");
            } else {
                parms.put("AND_DRUG_FDC_scale_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_FDC_scale_NOT_NULL", "Y");
            } else {
                parms.put("AND_DRUG_FDC_scale_NOT_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_FDC_scale_EQUALS", "Y");
            } else {
                parms.put("AND_DRUG_FDC_scale_EQUALS", "Y");
            }
            parms.put("drugFdcScale", example.getDrugFdcScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_FDC_scale_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_DRUG_FDC_scale_NOT_EQUALS", "Y");
            }
            parms.put("drugFdcScale", example.getDrugFdcScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_FDC_scale_GT", "Y");
            } else {
                parms.put("AND_DRUG_FDC_scale_GT", "Y");
            }
            parms.put("drugFdcScale", example.getDrugFdcScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_FDC_scale_GE", "Y");
            } else {
                parms.put("AND_DRUG_FDC_scale_GE", "Y");
            }
            parms.put("drugFdcScale", example.getDrugFdcScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_FDC_scale_LT", "Y");
            } else {
                parms.put("AND_DRUG_FDC_scale_LT", "Y");
            }
            parms.put("drugFdcScale", example.getDrugFdcScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_DRUG_FDC_scale_LE", "Y");
            } else {
                parms.put("AND_DRUG_FDC_scale_LE", "Y");
            }
            parms.put("drugFdcScale", example.getDrugFdcScale());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    private Map getZDXKYZL_scaleExampleParms(PccPaPatientsManageFeeExample example) {
        Map parms = new HashMap();
        switch (example.getZdxkyzlScale_Indicator()) {
        case PccPaPatientsManageFeeExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ZDXKYZL_scale_NULL", "Y");
            } else {
                parms.put("AND_ZDXKYZL_scale_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ZDXKYZL_scale_NOT_NULL", "Y");
            } else {
                parms.put("AND_ZDXKYZL_scale_NOT_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ZDXKYZL_scale_EQUALS", "Y");
            } else {
                parms.put("AND_ZDXKYZL_scale_EQUALS", "Y");
            }
            parms.put("zdxkyzlScale", example.getZdxkyzlScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ZDXKYZL_scale_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_ZDXKYZL_scale_NOT_EQUALS", "Y");
            }
            parms.put("zdxkyzlScale", example.getZdxkyzlScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ZDXKYZL_scale_GT", "Y");
            } else {
                parms.put("AND_ZDXKYZL_scale_GT", "Y");
            }
            parms.put("zdxkyzlScale", example.getZdxkyzlScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ZDXKYZL_scale_GE", "Y");
            } else {
                parms.put("AND_ZDXKYZL_scale_GE", "Y");
            }
            parms.put("zdxkyzlScale", example.getZdxkyzlScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ZDXKYZL_scale_LT", "Y");
            } else {
                parms.put("AND_ZDXKYZL_scale_LT", "Y");
            }
            parms.put("zdxkyzlScale", example.getZdxkyzlScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_ZDXKYZL_scale_LE", "Y");
            } else {
                parms.put("AND_ZDXKYZL_scale_LE", "Y");
            }
            parms.put("zdxkyzlScale", example.getZdxkyzlScale());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    private Map getFFYZL_scaleExampleParms(PccPaPatientsManageFeeExample example) {
        Map parms = new HashMap();
        switch (example.getFfyzlScale_Indicator()) {
        case PccPaPatientsManageFeeExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FFYZL_scale_NULL", "Y");
            } else {
                parms.put("AND_FFYZL_scale_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FFYZL_scale_NOT_NULL", "Y");
            } else {
                parms.put("AND_FFYZL_scale_NOT_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FFYZL_scale_EQUALS", "Y");
            } else {
                parms.put("AND_FFYZL_scale_EQUALS", "Y");
            }
            parms.put("ffyzlScale", example.getFfyzlScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FFYZL_scale_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_FFYZL_scale_NOT_EQUALS", "Y");
            }
            parms.put("ffyzlScale", example.getFfyzlScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FFYZL_scale_GT", "Y");
            } else {
                parms.put("AND_FFYZL_scale_GT", "Y");
            }
            parms.put("ffyzlScale", example.getFfyzlScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FFYZL_scale_GE", "Y");
            } else {
                parms.put("AND_FFYZL_scale_GE", "Y");
            }
            parms.put("ffyzlScale", example.getFfyzlScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FFYZL_scale_LT", "Y");
            } else {
                parms.put("AND_FFYZL_scale_LT", "Y");
            }
            parms.put("ffyzlScale", example.getFfyzlScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_FFYZL_scale_LE", "Y");
            } else {
                parms.put("AND_FFYZL_scale_LE", "Y");
            }
            parms.put("ffyzlScale", example.getFfyzlScale());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    private Map getQTZL_scaleExampleParms(PccPaPatientsManageFeeExample example) {
        Map parms = new HashMap();
        switch (example.getQtzlScale_Indicator()) {
        case PccPaPatientsManageFeeExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_QTZL_scale_NULL", "Y");
            } else {
                parms.put("AND_QTZL_scale_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_QTZL_scale_NOT_NULL", "Y");
            } else {
                parms.put("AND_QTZL_scale_NOT_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_QTZL_scale_EQUALS", "Y");
            } else {
                parms.put("AND_QTZL_scale_EQUALS", "Y");
            }
            parms.put("qtzlScale", example.getQtzlScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_QTZL_scale_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_QTZL_scale_NOT_EQUALS", "Y");
            }
            parms.put("qtzlScale", example.getQtzlScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_QTZL_scale_GT", "Y");
            } else {
                parms.put("AND_QTZL_scale_GT", "Y");
            }
            parms.put("qtzlScale", example.getQtzlScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_QTZL_scale_GE", "Y");
            } else {
                parms.put("AND_QTZL_scale_GE", "Y");
            }
            parms.put("qtzlScale", example.getQtzlScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_QTZL_scale_LT", "Y");
            } else {
                parms.put("AND_QTZL_scale_LT", "Y");
            }
            parms.put("qtzlScale", example.getQtzlScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_QTZL_scale_LE", "Y");
            } else {
                parms.put("AND_QTZL_scale_LE", "Y");
            }
            parms.put("qtzlScale", example.getQtzlScale());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    private Map getYYJTBZ_scaleExampleParms(PccPaPatientsManageFeeExample example) {
        Map parms = new HashMap();
        switch (example.getYyjtbzScale_Indicator()) {
        case PccPaPatientsManageFeeExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_YYJTBZ_scale_NULL", "Y");
            } else {
                parms.put("AND_YYJTBZ_scale_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_YYJTBZ_scale_NOT_NULL", "Y");
            } else {
                parms.put("AND_YYJTBZ_scale_NOT_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_YYJTBZ_scale_EQUALS", "Y");
            } else {
                parms.put("AND_YYJTBZ_scale_EQUALS", "Y");
            }
            parms.put("yyjtbzScale", example.getYyjtbzScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_YYJTBZ_scale_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_YYJTBZ_scale_NOT_EQUALS", "Y");
            }
            parms.put("yyjtbzScale", example.getYyjtbzScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_YYJTBZ_scale_GT", "Y");
            } else {
                parms.put("AND_YYJTBZ_scale_GT", "Y");
            }
            parms.put("yyjtbzScale", example.getYyjtbzScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_YYJTBZ_scale_GE", "Y");
            } else {
                parms.put("AND_YYJTBZ_scale_GE", "Y");
            }
            parms.put("yyjtbzScale", example.getYyjtbzScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_YYJTBZ_scale_LT", "Y");
            } else {
                parms.put("AND_YYJTBZ_scale_LT", "Y");
            }
            parms.put("yyjtbzScale", example.getYyjtbzScale());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_YYJTBZ_scale_LE", "Y");
            } else {
                parms.put("AND_YYJTBZ_scale_LE", "Y");
            }
            parms.put("yyjtbzScale", example.getYyjtbzScale());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    private Map gettotal_FEEExampleParms(PccPaPatientsManageFeeExample example) {
        Map parms = new HashMap();
        switch (example.getTotalFee_Indicator()) {
        case PccPaPatientsManageFeeExample.EXAMPLE_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_total_FEE_NULL", "Y");
            } else {
                parms.put("AND_total_FEE_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_NULL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_total_FEE_NOT_NULL", "Y");
            } else {
                parms.put("AND_total_FEE_NOT_NULL", "Y");
            }
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_total_FEE_EQUALS", "Y");
            } else {
                parms.put("AND_total_FEE_EQUALS", "Y");
            }
            parms.put("totalFee", example.getTotalFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_NOT_EQUALS:
            if (example.isCombineTypeOr()) {
                parms.put("OR_total_FEE_NOT_EQUALS", "Y");
            } else {
                parms.put("AND_total_FEE_NOT_EQUALS", "Y");
            }
            parms.put("totalFee", example.getTotalFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_total_FEE_GT", "Y");
            } else {
                parms.put("AND_total_FEE_GT", "Y");
            }
            parms.put("totalFee", example.getTotalFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_GREATER_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_total_FEE_GE", "Y");
            } else {
                parms.put("AND_total_FEE_GE", "Y");
            }
            parms.put("totalFee", example.getTotalFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN:
            if (example.isCombineTypeOr()) {
                parms.put("OR_total_FEE_LT", "Y");
            } else {
                parms.put("AND_total_FEE_LT", "Y");
            }
            parms.put("totalFee", example.getTotalFee());
            break;
        case PccPaPatientsManageFeeExample.EXAMPLE_LESS_THAN_OR_EQUAL:
            if (example.isCombineTypeOr()) {
                parms.put("OR_total_FEE_LE", "Y");
            } else {
                parms.put("AND_total_FEE_LE", "Y");
            }
            parms.put("totalFee", example.getTotalFee());
            break;
        }
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    private Map getExampleParms(PccPaPatientsManageFeeExample example) {
        Map parms = new HashMap();
        parms.putAll(getIDExampleParms(example));
        parms.putAll(getFISCAL_YEARExampleParms(example));
        parms.putAll(getFROM_AREAExampleParms(example));
        parms.putAll(getSORT_IDExampleParms(example));
        parms.putAll(getPATIENTSExampleParms(example));
        parms.putAll(getMANAGE_FEEExampleParms(example));
        parms.putAll(getDRUG_BSY_FEEExampleParms(example));
        parms.putAll(getDRUG_FDC_FEEExampleParms(example));
        parms.putAll(getZDXKYZL_FEEExampleParms(example));
        parms.putAll(getFFYZL_FEEExampleParms(example));
        parms.putAll(getQTZL_FEEExampleParms(example));
        parms.putAll(getYYJTBZ_FEEExampleParms(example));
        parms.putAll(getMANAGE_scaleExampleParms(example));
        parms.putAll(getDRUG_BSY_scaleExampleParms(example));
        parms.putAll(getDRUG_FDC_scaleExampleParms(example));
        parms.putAll(getZDXKYZL_scaleExampleParms(example));
        parms.putAll(getFFYZL_scaleExampleParms(example));
        parms.putAll(getQTZL_scaleExampleParms(example));
        parms.putAll(getYYJTBZ_scaleExampleParms(example));
        parms.putAll(gettotal_FEEExampleParms(example));
        return parms;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    public int selectCountByExample(PccPaPatientsManageFeeExample example) {
        Map parms = getExampleParms(example);
        int count = ((Integer)getSqlMapClientTemplate().queryForObject("pcc_pa_patients_manage_fee.abatorgenerated_selectCountByExample", parms)).intValue();
        return count;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    public PageBox selectByExampleWithPaging(PccPaPatientsManageFeeExample example, int pageSize, int pageNum, String orderByClause) {
        Map parms = getExampleParms(example);
        if (orderByClause != null) {
            parms.put("ABATOR_ORDER_BY_CLAUSE", orderByClause);
        }
        PageBox pageBox = new PageBox();
        PageObject pageObject = new PageObject();
        pageObject.setPageSize(pageSize);
        pageObject.setPageIndex(pageNum);
        int itemAmount = selectCountByExample(example);
        pageObject.setItemAmount(itemAmount);
        List pageList = null;
        if (pageObject.getBeginIndex() <= pageObject.getItemAmount()) {
            pageList = (getSqlMapClientTemplate().queryForList("pcc_pa_patients_manage_fee.abatorgenerated_selectByExample", parms, pageObject.getBeginIndex() - 1, pageSize));
        }
        pageBox.setPageObject(pageObject);
        pageBox.setPageList(pageList);
        return pageBox;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    public PageBox selectByExampleWithPaging(PccPaPatientsManageFeeExample example, int pageSize, int pageNum) {
        return selectByExampleWithPaging(example, pageSize, pageNum, null);
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table pcc_pa_patients_manage_fee
     *
     * @abatorgenerated Tue Apr 17 10:39:39 CST 2012
     */
    public int updateByPrimaryKeyForCgs(PccPaPatientsManageFee record) {
        int rows = getSqlMapClientTemplate().update("pcc_pa_patients_manage_fee.abatorgenerated_updateByPrimaryKeyForCgs", record);
        return rows;
    }
}